The Microsoft Date and Time Picker Control is missing in my excell developer insert controls, more controls buttom

The date and time picker control is part of the Windows Common controls.  The file is MSCOMCT2.OCX, located in C:\Windows\System32 on 32-bit or C:\Windows\Syswow64 on 64-bit.  If you don't have this file, you can download it from the following location:

http://activex.microsoft.com/controls/vb6/MSCOMCT2.cab

Once you download the file, you'll need to extract the files and then register the OCX file.  You will likely need to open the command prompt as administrator in order to get the file to register successfully.  Here are the steps in case you need them.

* Go to Start\All Programs\Accessories.
* Right-click Command Prompt and then click on Run As Administrator. 
* Change directory to the folder where you extracted the files.  For example, type the following and then press Enter:  cd c:\windows\system32
* Type the following and then press Enter:  regsvr32 mscomct2.ocx
* You should get a message saying this succeeded.

I hope this helps!

Source Link: http://social.technet.microsoft.com/Forums/office/en-US/defdd35a-f285-4b84-bf4c-d62011823b37/access-2010-datepicker-control-missing

Tony Chen
TechNet Community Support

The date and time picker control is part of the Windows Common controls.  The file is MSCOMCT2.OCX, located in C:\Windows\System32 on 32-bit or C:\Windows\Syswow64 on 64-bit.  If you don't have this file, you can download it from the following location:

http://activex.microsoft.com/controls/vb6/MSCOMCT2.cab

Once you download the file, you'll need to extract the files and then register the OCX file.  You will likely need to open the command prompt as administrator in order to get the file to register successfully.  Here are the steps in case you need them.

* Go to Start\All Programs\Accessories.
* Right-click Command Prompt and then click on Run As Administrator. 
* Change directory to the folder where you extracted the files.  For example, type the following and then press Enter:  cd c:\windows\system32
* Type the following and then press Enter:  regsvr32 mscomct2.ocx
* You should get a message saying this succeeded.

I hope this helps!

Source Link: http://social.technet.microsoft.com/Forums/office/en-US/defdd35a-f285-4b84-bf4c-d62011823b37/access-2010-datepicker-control-missing

Tony Chen
TechNet Community Support

• Marked as answer by Tony Chen CHNMicrosoft contingent staff, Moderator Thursday, August 15, 2013 1:20 PM

The date and time picker control is part of the Windows Common controls.  The file is MSCOMCT2.OCX, located in C:\Windows\System32 on 32-bit or C:\Windows\Syswow64 on 64-bit.  If you don't have this file, you can download it from the following location:

http://activex.microsoft.com/controls/vb6/MSCOMCT2.cab

Once you download the file, you'll need to extract the files and then register the OCX file.  You will likely need to open the command prompt as administrator in order to get the file to register successfully.  Here are the steps in case you need them.

* Go to Start\All Programs\Accessories.
* Right-click Command Prompt and then click on Run As Administrator. 
* Change directory to the folder where you extracted the files.  For example, type the following and then press Enter:  cd c:\windows\system32
* Type the following and then press Enter:  regsvr32 mscomct2.ocx
* You should get a message saying this succeeded.

I hope this helps!

Source Link: http://social.technet.microsoft.com/Forums/office/en-US/defdd35a-f285-4b84-bf4c-d62011823b37/access-2010-datepicker-control-missing

Tony Chen
TechNet Community Support

• Marked as answer by Tony Chen CHNMicrosoft contingent staff, Moderator Thursday, August 15, 2013 1:20 PM

The date and time picker control is part of the Windows Common controls.  The file is MSCOMCT2.OCX, located in C:\Windows\System32 on 32-bit or C:\Windows\Syswow64 on 64-bit.  If you don't have this file, you can download it from the following location:

http://activex.microsoft.com/controls/vb6/MSCOMCT2.cab

Once you download the file, you'll need to extract the files and then register the OCX file.  You will likely need to open the command prompt as administrator in order to get the file to register successfully.  Here are the steps in case you need them.

* Go to Start\All Programs\Accessories.
* Right-click Command Prompt and then click on Run As Administrator. 
* Change directory to the folder where you extracted the files.  For example, type the following and then press Enter:  cd c:\windows\system32
* Type the following and then press Enter:  regsvr32 mscomct2.ocx
* You should get a message saying this succeeded.

I hope this helps!

Source Link: http://social.technet.microsoft.com/Forums/office/en-US/defdd35a-f285-4b84-bf4c-d62011823b37/access-2010-datepicker-control-missing

Tony Chen
TechNet Community Support

• Marked as answer by Tony Chen CHNMicrosoft contingent staff, Moderator Thursday, August 15, 2013 1:20 PM

I am trying to use the ActiveX datetime picker in a Win 64 environment, but using 32-bit Office as a way for users to set the date and time of an event. My application uses Access 2010 front end and SQL Server back end. There is no end of discussions for how to do a date entry on the web, and little useful discussion about dealing with times. Through playing around, I am reasonably happy with the datetime picker from "the past". My instance in Access shows the class as MSComCtl2.DTPicker.2.

What's missing for me is a help file. When I use the Access properties window, place the cursor in a property value and press F1 to learn more about the property, I get the usual tired MS help screen that is nothing more than a regurgiation of the control name spelled out, or no help at all. If I use the custom properties dialog via the control context menu, and click the help button on that screen, I am told I'm missing the cmctl298.chm file in the WOW64 folder. I thought maybe this was an old "64-bit install doesn't register correctly" issue, but I've searched my hard drive, and there is no such file.

I've done the Google, MSDN, and TechNet dances, but I am not having any luck finding this help file so far from a source I know and trust. There are always places on the web that claim to have any file one looks for, but I won't install MS products from any source other than Microsoft. Been there, done that, been burned.

I have every version of Windows, Office, and VS that has ever been released. Can someone tell me where to find the help file or some detailed documentation for how this control works with Access (I've found .net docs, but the vast majority of the properties and methods discussed there I do not believe are exposed to the Access interface and the ones I am interested in leasrning more about are not in the documentation).

Maybe I'm also barking up the wrong tree. If there is a more modern control I should be using, I'm good with it, as long as I do not have to install anything at the system level on the client machines (there are thousands of them all over the world with centralized IT managed from another country, so I cannot add or subtract from the Windows installation, and cannot install updates to Windows or Office).

Thanks in advance to anyone who has some direction for me on this one.

Thanks!!! It worked

this is crazy.

i'm a novice, All i want is a calendar box i can select a date from without manually inputting it. i have spent nearly 6 hours trying to get it to work. but nothing.

i have downloaded mscomct2 and put it in system32 and confirmed it had succeeded. on further advice, i have even put it in sysWOW because i have windows 8 64 bit. and it succeeded.

but nothing. no date time active controls available in 'developer - insert - more controls'.

isnt this a basic thing? how can microsoft miss this? why is it so difficult??

PLEASE!!! - can someone give me a basic simple solution. or a basic reason why you cant. please remember i'm a novice